Overview
Brought to you by YData
Dataset statistics
| Number of variables | 25 |
|---|---|
| Number of observations | 10000 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.9 MiB |
| Average record size in memory | 200.0 B |
Variable types
| Text | 3 |
|---|---|
| DateTime | 4 |
| Numeric | 6 |
| Categorical | 11 |
| Boolean | 1 |
loan_amount_allowed is highly overall correlated with sum_assured_inr/coverage_amount | High correlation |
payment_frequency is highly overall correlated with payment_frequency_days | High correlation |
payment_frequency_days is highly overall correlated with payment_frequency | High correlation |
policy_code is highly overall correlated with policy_type_code and 1 other fields | High correlation |
policy_type_code is highly overall correlated with policy_code and 1 other fields | High correlation |
purchase_month is highly overall correlated with purchase_quarter | High correlation |
purchase_quarter is highly overall correlated with purchase_month | High correlation |
rm_id is highly overall correlated with sales_agent_code and 2 other fields | High correlation |
sales_agent_code is highly overall correlated with rm_id and 2 other fields | High correlation |
state is highly overall correlated with rm_id and 2 other fields | High correlation |
sum_assured_inr/coverage_amount is highly overall correlated with loan_amount_allowed | High correlation |
tenure_(years) is highly overall correlated with policy_code and 1 other fields | High correlation |
zonal_manager_id is highly overall correlated with rm_id and 2 other fields | High correlation |
policy_status is highly imbalanced (53.5%) | Imbalance |
sum_assured_inr/coverage_amount has unique values | Unique |
Reproduction
| Analysis started | 2025-11-11 14:19:42.341636 |
|---|---|
| Analysis finished | 2025-11-11 14:19:58.878970 |
| Duration | 16.54 seconds |
| Software version | ydata-profiling vv4.17.0 |
| Download configuration | config.json |
Variables
policy_number
Text
| Distinct | 9938 |
|---|---|
| Distinct (%) | 99.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 14 |
| Min length | 14 |
Unique
| Unique | 9876 ? |
|---|---|
| Unique (%) | 98.8% |
Sample
| 1st row | TRS-POL-287638 |
|---|---|
| 2nd row | TRS-POL-983850 |
| 3rd row | TRS-POL-892387 |
| 4th row | TRS-POL-204292 |
| 5th row | TRS-POL-621019 |
| Value | Count | Frequency (%) |
| trs-pol-266400 | 2 | < 0.1% |
| trs-pol-114616 | 2 | < 0.1% |
| trs-pol-762117 | 2 | < 0.1% |
| trs-pol-833719 | 2 | < 0.1% |
| trs-pol-314657 | 2 | < 0.1% |
| trs-pol-347852 | 2 | < 0.1% |
| trs-pol-299262 | 2 | < 0.1% |
| trs-pol-248874 | 2 | < 0.1% |
| trs-pol-147304 | 2 | < 0.1% |
| trs-pol-192272 | 2 | < 0.1% |
| Other values (9928) | 9980 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 20000 | |
| T | 10000 | 7.1% |
| R | 10000 | 7.1% |
| S | 10000 | 7.1% |
| P | 10000 | 7.1% |
| O | 10000 | 7.1% |
| L | 10000 | 7.1% |
| 6 | 6234 | 4.5% |
| 2 | 6171 | 4.4% |
| 7 | 6131 | 4.4% |
| Other values (7) | 41464 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 140000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 20000 | |
| T | 10000 | 7.1% |
| R | 10000 | 7.1% |
| S | 10000 | 7.1% |
| P | 10000 | 7.1% |
| O | 10000 | 7.1% |
| L | 10000 | 7.1% |
| 6 | 6234 | 4.5% |
| 2 | 6171 | 4.4% |
| 7 | 6131 | 4.4% |
| Other values (7) | 41464 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 140000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 20000 | |
| T | 10000 | 7.1% |
| R | 10000 | 7.1% |
| S | 10000 | 7.1% |
| P | 10000 | 7.1% |
| O | 10000 | 7.1% |
| L | 10000 | 7.1% |
| 6 | 6234 | 4.5% |
| 2 | 6171 | 4.4% |
| 7 | 6131 | 4.4% |
| Other values (7) | 41464 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 140000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 20000 | |
| T | 10000 | 7.1% |
| R | 10000 | 7.1% |
| S | 10000 | 7.1% |
| P | 10000 | 7.1% |
| O | 10000 | 7.1% |
| L | 10000 | 7.1% |
| 6 | 6234 | 4.5% |
| 2 | 6171 | 4.4% |
| 7 | 6131 | 4.4% |
| Other values (7) | 41464 |
start_date
Date
| Distinct | 3237 |
|---|---|
| Distinct (%) | 32.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| Minimum | 2015-01-08 00:00:00 |
|---|---|
| Maximum | 2024-12-31 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
last_paid_date
Date
| Distinct | 1841 |
|---|---|
| Distinct (%) | 18.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| Minimum | 2016-03-28 00:00:00 |
|---|---|
| Maximum | 2025-12-31 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
tenure_(years)
Real number (ℝ)
High correlation
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18.1789 |
| Minimum | 10 |
|---|---|
| Maximum | 25 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | 10 |
|---|---|
| 5-th percentile | 10 |
| Q1 | 12 |
| median | 20 |
| Q3 | 20 |
| 95-th percentile | 25 |
| Maximum | 25 |
| Range | 15 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 5.4460867 |
|---|---|
| Coefficient of variation (CV) | 0.29958285 |
| Kurtosis | -1.2798103 |
| Mean | 18.1789 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | -0.32459948 |
| Sum | 181789 |
| Variance | 29.659861 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 20 | 4177 | |
| 25 | 2358 | |
| 10 | 1818 | |
| 12 | 1235 | 12.3% |
| 15 | 395 | 4.0% |
| 22 | 17 | 0.2% |
| Value | Count | Frequency (%) |
| 10 | 1818 | |
| 12 | 1235 | 12.3% |
| 15 | 395 | 4.0% |
| 20 | 4177 | |
| 22 | 17 | 0.2% |
| 25 | 2358 |
| Value | Count | Frequency (%) |
| 25 | 2358 | |
| 22 | 17 | 0.2% |
| 20 | 4177 | |
| 15 | 395 | 4.0% |
| 12 | 1235 | 12.3% |
| 10 | 1818 |
date_of_purchase
Date
| Distinct | 3430 |
|---|---|
| Distinct (%) | 34.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| Minimum | 2015-07-24 00:00:00 |
|---|---|
| Maximum | 2025-07-23 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
customer_id
Text
| Distinct | 9945 |
|---|---|
| Distinct (%) | 99.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 11 |
| Min length | 11 |
Unique
| Unique | 9890 ? |
|---|---|
| Unique (%) | 98.9% |
Sample
| 1st row | CUST-912138 |
|---|---|
| 2nd row | CUST-676760 |
| 3rd row | CUST-189349 |
| 4th row | CUST-567423 |
| 5th row | CUST-292627 |
| Value | Count | Frequency (%) |
| cust-552109 | 2 | < 0.1% |
| cust-290945 | 2 | < 0.1% |
| cust-315473 | 2 | < 0.1% |
| cust-970713 | 2 | < 0.1% |
| cust-283690 | 2 | < 0.1% |
| cust-398973 | 2 | < 0.1% |
| cust-788106 | 2 | < 0.1% |
| cust-141656 | 2 | < 0.1% |
| cust-293235 | 2 | < 0.1% |
| cust-710477 | 2 | < 0.1% |
| Other values (9935) | 9980 |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 10000 | 9.1% |
| U | 10000 | 9.1% |
| S | 10000 | 9.1% |
| T | 10000 | 9.1% |
| - | 10000 | 9.1% |
| 4 | 6185 | 5.6% |
| 2 | 6170 | 5.6% |
| 5 | 6168 | 5.6% |
| 9 | 6168 | 5.6% |
| 6 | 6090 | 5.5% |
| Other values (5) | 29219 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 110000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| C | 10000 | 9.1% |
| U | 10000 | 9.1% |
| S | 10000 | 9.1% |
| T | 10000 | 9.1% |
| - | 10000 | 9.1% |
| 4 | 6185 | 5.6% |
| 2 | 6170 | 5.6% |
| 5 | 6168 | 5.6% |
| 9 | 6168 | 5.6% |
| 6 | 6090 | 5.5% |
| Other values (5) | 29219 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 110000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| C | 10000 | 9.1% |
| U | 10000 | 9.1% |
| S | 10000 | 9.1% |
| T | 10000 | 9.1% |
| - | 10000 | 9.1% |
| 4 | 6185 | 5.6% |
| 2 | 6170 | 5.6% |
| 5 | 6168 | 5.6% |
| 9 | 6168 | 5.6% |
| 6 | 6090 | 5.5% |
| Other values (5) | 29219 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 110000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| C | 10000 | 9.1% |
| U | 10000 | 9.1% |
| S | 10000 | 9.1% |
| T | 10000 | 9.1% |
| - | 10000 | 9.1% |
| 4 | 6185 | 5.6% |
| 2 | 6170 | 5.6% |
| 5 | 6168 | 5.6% |
| 9 | 6168 | 5.6% |
| 6 | 6090 | 5.5% |
| Other values (5) | 29219 |
sum_assured_inr/coverage_amount
Real number (ℝ)
High correlation Unique
| Distinct | 10000 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1054222.3 |
| Minimum | 100316.82 |
|---|---|
| Maximum | 1999546.8 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | 100316.82 |
|---|---|
| 5-th percentile | 196491.26 |
| Q1 | 577241.91 |
| median | 1059397.7 |
| Q3 | 1527198.5 |
| 95-th percentile | 1907294.4 |
| Maximum | 1999546.8 |
| Range | 1899229.9 |
| Interquartile range (IQR) | 949956.59 |
Descriptive statistics
| Standard deviation | 549260.89 |
|---|---|
| Coefficient of variation (CV) | 0.52101051 |
| Kurtosis | -1.2055452 |
| Mean | 1054222.3 |
| Median Absolute Deviation (MAD) | 475548.59 |
| Skewness | -0.0035187733 |
| Sum | 1.0542223 × 1010 |
| Variance | 3.0168752 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 684200.64 | 1 | < 0.1% |
| 1006981.05 | 1 | < 0.1% |
| 391180.06 | 1 | < 0.1% |
| 1153296.54 | 1 | < 0.1% |
| 1176121.67 | 1 | < 0.1% |
| 1572200.77 | 1 | < 0.1% |
| 1735695.76 | 1 | < 0.1% |
| 1185416.85 | 1 | < 0.1% |
| 995666.54 | 1 | < 0.1% |
| 662242.36 | 1 | < 0.1% |
| Other values (9990) | 9990 |
| Value | Count | Frequency (%) |
| 100316.82 | 1 | |
| 100333.64 | 1 | |
| 100632.55 | 1 | |
| 100665.03 | 1 | |
| 100709.94 | 1 | |
| 100828.11 | 1 | |
| 101628.27 | 1 | |
| 101648.77 | 1 | |
| 102350.25 | 1 | |
| 102430.36 | 1 |
| Value | Count | Frequency (%) |
| 1999546.76 | 1 | |
| 1999441.68 | 1 | |
| 1999264.17 | 1 | |
| 1998796.46 | 1 | |
| 1998525.18 | 1 | |
| 1998314.16 | 1 | |
| 1998311.26 | 1 | |
| 1998270.05 | 1 | |
| 1997605.61 | 1 | |
| 1997550.35 | 1 |
premium_amount
Real number (ℝ)
| Distinct | 9995 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 52261.483 |
| Minimum | 5028.98 |
|---|---|
| Maximum | 99997.01 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | 5028.98 |
|---|---|
| 5-th percentile | 9641.422 |
| Q1 | 28251.645 |
| median | 52362.055 |
| Q3 | 76051.84 |
| 95-th percentile | 95333.279 |
| Maximum | 99997.01 |
| Range | 94968.03 |
| Interquartile range (IQR) | 47800.195 |
Descriptive statistics
| Standard deviation | 27511.888 |
|---|---|
| Coefficient of variation (CV) | 0.52642762 |
| Kurtosis | -1.2063144 |
| Mean | 52261.483 |
| Median Absolute Deviation (MAD) | 23881.73 |
| Skewness | 0.011607776 |
| Sum | 5.2261483 × 108 |
| Variance | 7.5690399 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 63835.33 | 2 | < 0.1% |
| 58252.59 | 2 | < 0.1% |
| 41203.82 | 2 | < 0.1% |
| 52662.24 | 2 | < 0.1% |
| 20252.27 | 2 | < 0.1% |
| 25882.43 | 1 | < 0.1% |
| 62045.93 | 1 | < 0.1% |
| 5973.76 | 1 | < 0.1% |
| 33635.08 | 1 | < 0.1% |
| 47823.59 | 1 | < 0.1% |
| Other values (9985) | 9985 |
| Value | Count | Frequency (%) |
| 5028.98 | 1 | |
| 5055.75 | 1 | |
| 5060.84 | 1 | |
| 5066.79 | 1 | |
| 5082.21 | 1 | |
| 5089.12 | 1 | |
| 5093.81 | 1 | |
| 5096.33 | 1 | |
| 5096.9 | 1 | |
| 5109.71 | 1 |
| Value | Count | Frequency (%) |
| 99997.01 | 1 | |
| 99976.71 | 1 | |
| 99974.54 | 1 | |
| 99965.59 | 1 | |
| 99958.74 | 1 | |
| 99944.01 | 1 | |
| 99938.14 | 1 | |
| 99932.81 | 1 | |
| 99925.51 | 1 | |
| 99920.71 | 1 |
payment_frequency
Categorical
High correlation
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| Quarterly | |
|---|---|
| Monthly | |
| Annually |
Length
| Max length | 9 |
|---|---|
| Median length | 8 |
| Mean length | 8.0108 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Monthly |
|---|---|
| 2nd row | Annually |
| 3rd row | Quarterly |
| 4th row | Annually |
| 5th row | Monthly |
Common Values
| Value | Count | Frequency (%) |
| Quarterly | 3432 | |
| Monthly | 3324 | |
| Annually | 3244 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| quarterly | 3432 | |
| monthly | 3324 | |
| annually | 3244 |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 13244 | |
| y | 10000 | |
| n | 9812 | |
| r | 6864 | |
| t | 6756 | |
| a | 6676 | |
| u | 6676 | |
| Q | 3432 | 4.3% |
| e | 3432 | 4.3% |
| M | 3324 | 4.1% |
| Other values (3) | 9892 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 80108 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| l | 13244 | |
| y | 10000 | |
| n | 9812 | |
| r | 6864 | |
| t | 6756 | |
| a | 6676 | |
| u | 6676 | |
| Q | 3432 | 4.3% |
| e | 3432 | 4.3% |
| M | 3324 | 4.1% |
| Other values (3) | 9892 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 80108 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| l | 13244 | |
| y | 10000 | |
| n | 9812 | |
| r | 6864 | |
| t | 6756 | |
| a | 6676 | |
| u | 6676 | |
| Q | 3432 | 4.3% |
| e | 3432 | 4.3% |
| M | 3324 | 4.1% |
| Other values (3) | 9892 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 80108 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| l | 13244 | |
| y | 10000 | |
| n | 9812 | |
| r | 6864 | |
| t | 6756 | |
| a | 6676 | |
| u | 6676 | |
| Q | 3432 | 4.3% |
| e | 3432 | 4.3% |
| M | 3324 | 4.1% |
| Other values (3) | 9892 |
| Value | Count | Frequency (%) |
| True | 5108 | |
| False | 4892 |
loan_amount_allowed
Real number (ℝ)
High correlation
| Distinct | 9999 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 475327.13 |
| Minimum | 30894.54 |
|---|---|
| Maximum | 1181952.2 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | 30894.54 |
|---|---|
| 5-th percentile | 85841.391 |
| Q1 | 248153.4 |
| median | 457602.98 |
| Q3 | 672625.19 |
| 95-th percentile | 950570.58 |
| Maximum | 1181952.2 |
| Range | 1151057.6 |
| Interquartile range (IQR) | 424471.79 |
Descriptive statistics
| Standard deviation | 267747.04 |
|---|---|
| Coefficient of variation (CV) | 0.56329005 |
| Kurtosis | -0.77715878 |
| Mean | 475327.13 |
| Median Absolute Deviation (MAD) | 211792.03 |
| Skewness | 0.30950321 |
| Sum | 4.7532713 × 109 |
| Variance | 7.1688479 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 687043.28 | 2 | < 0.1% |
| 447163.56 | 1 | < 0.1% |
| 251903.5 | 1 | < 0.1% |
| 513299.27 | 1 | < 0.1% |
| 199802.21 | 1 | < 0.1% |
| 709501.06 | 1 | < 0.1% |
| 73432.27 | 1 | < 0.1% |
| 361902.11 | 1 | < 0.1% |
| 732352.54 | 1 | < 0.1% |
| 864927.02 | 1 | < 0.1% |
| Other values (9989) | 9989 |
| Value | Count | Frequency (%) |
| 30894.54 | 1 | |
| 32478.83 | 1 | |
| 32687.28 | 1 | |
| 32738.11 | 1 | |
| 33423.82 | 1 | |
| 34203.18 | 1 | |
| 34449.91 | 1 | |
| 34992.62 | 1 | |
| 35106.17 | 1 | |
| 35398.12 | 1 |
| Value | Count | Frequency (%) |
| 1181952.17 | 1 | |
| 1180406.45 | 1 | |
| 1180065.66 | 1 | |
| 1173589.5 | 1 | |
| 1168924.57 | 1 | |
| 1166546.6 | 1 | |
| 1163269.88 | 1 | |
| 1161643.03 | 1 | |
| 1161325.84 | 1 | |
| 1161317.06 | 1 |
underwriting_expenses
Real number (ℝ)
| Distinct | 9938 |
|---|---|
| Distinct (%) | 99.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5270.0628 |
| Minimum | 500.6 |
|---|---|
| Maximum | 9999.78 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | 500.6 |
|---|---|
| 5-th percentile | 971.745 |
| Q1 | 2853.765 |
| median | 5264.165 |
| Q3 | 7702.4975 |
| 95-th percentile | 9542.81 |
| Maximum | 9999.78 |
| Range | 9499.18 |
| Interquartile range (IQR) | 4848.7325 |
Descriptive statistics
| Standard deviation | 2774.4241 |
|---|---|
| Coefficient of variation (CV) | 0.52644991 |
| Kurtosis | -1.2283104 |
| Mean | 5270.0628 |
| Median Absolute Deviation (MAD) | 2422.77 |
| Skewness | -0.0086640626 |
| Sum | 52700628 |
| Variance | 7697429.1 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8312.83 | 2 | < 0.1% |
| 1976.24 | 2 | < 0.1% |
| 2890.14 | 2 | < 0.1% |
| 2861.03 | 2 | < 0.1% |
| 8542.35 | 2 | < 0.1% |
| 9036.62 | 2 | < 0.1% |
| 4537.45 | 2 | < 0.1% |
| 1290.93 | 2 | < 0.1% |
| 6207.64 | 2 | < 0.1% |
| 5208.18 | 2 | < 0.1% |
| Other values (9928) | 9980 |
| Value | Count | Frequency (%) |
| 500.6 | 1 | |
| 500.7 | 1 | |
| 501.09 | 1 | |
| 501.27 | 1 | |
| 502.19 | 1 | |
| 502.21 | 1 | |
| 502.29 | 1 | |
| 502.37 | 1 | |
| 503.83 | 1 | |
| 504.06 | 1 |
| Value | Count | Frequency (%) |
| 9999.78 | 1 | |
| 9998.66 | 1 | |
| 9998.65 | 1 | |
| 9998.47 | 1 | |
| 9998.31 | 1 | |
| 9997.82 | 1 | |
| 9997.47 | 1 | |
| 9996.08 | 1 | |
| 9994.77 | 1 | |
| 9994.62 | 1 |
sales_agent_code
Categorical
High correlation
| Distinct | 22 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| AGT-6578 | |
|---|---|
| AGT-3567 | |
| AGT-3488 | |
| AGT-3150 | |
| AGT-2345 | |
| Other values (17) |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | AGT-6578 |
|---|---|
| 2nd row | AGT-6578 |
| 3rd row | AGT-6578 |
| 4th row | AGT-6578 |
| 5th row | AGT-6578 |
Common Values
| Value | Count | Frequency (%) |
| AGT-6578 | 1221 | |
| AGT-3567 | 1120 | |
| AGT-3488 | 1009 | 10.1% |
| AGT-3150 | 819 | 8.2% |
| AGT-2345 | 637 | 6.4% |
| AGT-5980 | 612 | 6.1% |
| AGT-3465 | 550 | 5.5% |
| AGT-4456 | 512 | 5.1% |
| AGT-5467 | 463 | 4.6% |
| AGT-7898 | 458 | 4.6% |
| Other values (12) | 2599 |
Length
| Value | Count | Frequency (%) |
| agt-6578 | 1221 | |
| agt-3567 | 1120 | |
| agt-3488 | 1009 | 10.1% |
| agt-3150 | 819 | 8.2% |
| agt-2345 | 637 | 6.4% |
| agt-5980 | 612 | 6.1% |
| agt-3465 | 550 | 5.5% |
| agt-4456 | 512 | 5.1% |
| agt-5467 | 463 | 4.6% |
| agt-7898 | 458 | 4.6% |
| Other values (12) | 2599 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 10000 | |
| G | 10000 | |
| T | 10000 | |
| - | 10000 | |
| 5 | 7322 | |
| 4 | 5784 | |
| 8 | 5703 | |
| 3 | 4385 | |
| 6 | 3967 | 5.0% |
| 9 | 3687 | 4.6% |
| Other values (4) | 9152 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 80000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 10000 | |
| G | 10000 | |
| T | 10000 | |
| - | 10000 | |
| 5 | 7322 | |
| 4 | 5784 | |
| 8 | 5703 | |
| 3 | 4385 | |
| 6 | 3967 | 5.0% |
| 9 | 3687 | 4.6% |
| Other values (4) | 9152 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 80000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 10000 | |
| G | 10000 | |
| T | 10000 | |
| - | 10000 | |
| 5 | 7322 | |
| 4 | 5784 | |
| 8 | 5703 | |
| 3 | 4385 | |
| 6 | 3967 | 5.0% |
| 9 | 3687 | 4.6% |
| Other values (4) | 9152 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 80000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 10000 | |
| G | 10000 | |
| T | 10000 | |
| - | 10000 | |
| 5 | 7322 | |
| 4 | 5784 | |
| 8 | 5703 | |
| 3 | 4385 | |
| 6 | 3967 | 5.0% |
| 9 | 3687 | 4.6% |
| Other values (4) | 9152 |
purchase_month
Categorical
High correlation
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| December | |
|---|---|
| March | |
| August | |
| January | |
| July | |
| Other values (7) |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 6.165 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | January |
|---|---|
| 2nd row | October |
| 3rd row | April |
| 4th row | November |
| 5th row | February |
Common Values
| Value | Count | Frequency (%) |
| December | 892 | |
| March | 874 | |
| August | 866 | |
| January | 855 | |
| July | 841 | |
| November | 840 | |
| October | 828 | |
| May | 827 | |
| April | 825 | |
| September | 817 | |
| Other values (2) | 1535 |
Length
| Value | Count | Frequency (%) |
| december | 892 | |
| march | 874 | |
| august | 866 | |
| january | 855 | |
| july | 841 | |
| november | 840 | |
| october | 828 | |
| may | 827 | |
| april | 825 | |
| september | 817 | |
| Other values (2) | 1535 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 9170 | |
| r | 7423 | |
| u | 4963 | 8.1% |
| a | 4157 | 6.7% |
| b | 4123 | 6.7% |
| y | 3269 | 5.3% |
| c | 2594 | 4.2% |
| m | 2549 | 4.1% |
| t | 2511 | 4.1% |
| J | 2485 | 4.0% |
| Other values (16) | 18406 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 61650 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 9170 | |
| r | 7423 | |
| u | 4963 | 8.1% |
| a | 4157 | 6.7% |
| b | 4123 | 6.7% |
| y | 3269 | 5.3% |
| c | 2594 | 4.2% |
| m | 2549 | 4.1% |
| t | 2511 | 4.1% |
| J | 2485 | 4.0% |
| Other values (16) | 18406 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 61650 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 9170 | |
| r | 7423 | |
| u | 4963 | 8.1% |
| a | 4157 | 6.7% |
| b | 4123 | 6.7% |
| y | 3269 | 5.3% |
| c | 2594 | 4.2% |
| m | 2549 | 4.1% |
| t | 2511 | 4.1% |
| J | 2485 | 4.0% |
| Other values (16) | 18406 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 61650 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 9170 | |
| r | 7423 | |
| u | 4963 | 8.1% |
| a | 4157 | 6.7% |
| b | 4123 | 6.7% |
| y | 3269 | 5.3% |
| c | 2594 | 4.2% |
| m | 2549 | 4.1% |
| t | 2511 | 4.1% |
| J | 2485 | 4.0% |
| Other values (16) | 18406 |
purchase_quarter
Categorical
High correlation
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| Q4 | |
|---|---|
| Q3 | |
| Q1 | |
| Q2 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Q1 |
|---|---|
| 2nd row | Q4 |
| 3rd row | Q2 |
| 4th row | Q4 |
| 5th row | Q1 |
Common Values
| Value | Count | Frequency (%) |
| Q4 | 2560 | |
| Q3 | 2524 | |
| Q1 | 2475 | |
| Q2 | 2441 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| q4 | 2560 | |
| q3 | 2524 | |
| q1 | 2475 | |
| q2 | 2441 |
Most occurring characters
| Value | Count | Frequency (%) |
| Q | 10000 | |
| 4 | 2560 | 12.8% |
| 3 | 2524 | 12.6% |
| 1 | 2475 | 12.4% |
| 2 | 2441 | 12.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 20000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| Q | 10000 | |
| 4 | 2560 | 12.8% |
| 3 | 2524 | 12.6% |
| 1 | 2475 | 12.4% |
| 2 | 2441 | 12.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 20000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| Q | 10000 | |
| 4 | 2560 | 12.8% |
| 3 | 2524 | 12.6% |
| 1 | 2475 | 12.4% |
| 2 | 2441 | 12.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 20000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| Q | 10000 | |
| 4 | 2560 | 12.8% |
| 3 | 2524 | 12.6% |
| 1 | 2475 | 12.4% |
| 2 | 2441 | 12.2% |
purchase_year
Real number (ℝ)
| Distinct | 11 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2020.0509 |
| Minimum | 2015 |
|---|---|
| Maximum | 2025 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | 2015 |
|---|---|
| 5-th percentile | 2016 |
| Q1 | 2018 |
| median | 2020 |
| Q3 | 2023 |
| 95-th percentile | 2025 |
| Maximum | 2025 |
| Range | 10 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 2.9134787 |
|---|---|
| Coefficient of variation (CV) | 0.0014422798 |
| Kurtosis | -1.1553952 |
| Mean | 2020.0509 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.004066033 |
| Sum | 20200509 |
| Variance | 8.488358 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2018 | 1092 | |
| 2022 | 1021 | |
| 2024 | 1019 | |
| 2016 | 994 | |
| 2019 | 990 | |
| 2021 | 983 | |
| 2020 | 977 | |
| 2023 | 974 | |
| 2017 | 953 | |
| 2025 | 548 |
| Value | Count | Frequency (%) |
| 2015 | 449 | |
| 2016 | 994 | |
| 2017 | 953 | |
| 2018 | 1092 | |
| 2019 | 990 | |
| 2020 | 977 | |
| 2021 | 983 | |
| 2022 | 1021 | |
| 2023 | 974 | |
| 2024 | 1019 |
| Value | Count | Frequency (%) |
| 2025 | 548 | |
| 2024 | 1019 | |
| 2023 | 974 | |
| 2022 | 1021 | |
| 2021 | 983 | |
| 2020 | 977 | |
| 2019 | 990 | |
| 2018 | 1092 | |
| 2017 | 953 | |
| 2016 | 994 |
| Distinct | 3428 |
|---|---|
| Distinct (%) | 34.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| Minimum | 2016-07-24 00:00:00 |
|---|---|
| Maximum | 2026-07-23 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
claim_id
Text
| Distinct | 9939 |
|---|---|
| Distinct (%) | 99.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Unique
| Unique | 9879 ? |
|---|---|
| Unique (%) | 98.8% |
Sample
| 1st row | CLM-163983 |
|---|---|
| 2nd row | CLM-729665 |
| 3rd row | CLM-655001 |
| 4th row | CLM-101156 |
| 5th row | CLM-762598 |
| Value | Count | Frequency (%) |
| clm-572815 | 3 | < 0.1% |
| clm-843033 | 2 | < 0.1% |
| clm-396245 | 2 | < 0.1% |
| clm-258697 | 2 | < 0.1% |
| clm-109753 | 2 | < 0.1% |
| clm-687562 | 2 | < 0.1% |
| clm-453110 | 2 | < 0.1% |
| clm-749378 | 2 | < 0.1% |
| clm-620062 | 2 | < 0.1% |
| clm-833308 | 2 | < 0.1% |
| Other values (9929) | 9979 |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 10000 | |
| L | 10000 | |
| M | 10000 | |
| - | 10000 | |
| 5 | 6217 | 6.2% |
| 7 | 6192 | 6.2% |
| 6 | 6140 | 6.1% |
| 3 | 6129 | 6.1% |
| 1 | 6114 | 6.1% |
| 2 | 6097 | 6.1% |
| Other values (4) | 23111 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 100000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| C | 10000 | |
| L | 10000 | |
| M | 10000 | |
| - | 10000 | |
| 5 | 6217 | 6.2% |
| 7 | 6192 | 6.2% |
| 6 | 6140 | 6.1% |
| 3 | 6129 | 6.1% |
| 1 | 6114 | 6.1% |
| 2 | 6097 | 6.1% |
| Other values (4) | 23111 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 100000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| C | 10000 | |
| L | 10000 | |
| M | 10000 | |
| - | 10000 | |
| 5 | 6217 | 6.2% |
| 7 | 6192 | 6.2% |
| 6 | 6140 | 6.1% |
| 3 | 6129 | 6.1% |
| 1 | 6114 | 6.1% |
| 2 | 6097 | 6.1% |
| Other values (4) | 23111 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 100000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| C | 10000 | |
| L | 10000 | |
| M | 10000 | |
| - | 10000 | |
| 5 | 6217 | 6.2% |
| 7 | 6192 | 6.2% |
| 6 | 6140 | 6.1% |
| 3 | 6129 | 6.1% |
| 1 | 6114 | 6.1% |
| 2 | 6097 | 6.1% |
| Other values (4) | 23111 |
policy_type_code
Categorical
High correlation
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| TR-ENDD989 | |
|---|---|
| TR-WHCD968 | |
| TR-UNCD988 |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | TR-UNCD988 |
|---|---|
| 2nd row | TR-UNCD988 |
| 3rd row | TR-UNCD988 |
| 4th row | TR-UNCD988 |
| 5th row | TR-UNCD988 |
Common Values
| Value | Count | Frequency (%) |
| TR-ENDD989 | 3383 | |
| TR-WHCD968 | 3347 | |
| TR-UNCD988 | 3270 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| tr-endd989 | 3383 | |
| tr-whcd968 | 3347 | |
| tr-uncd988 | 3270 |
Most occurring characters
| Value | Count | Frequency (%) |
| D | 13383 | |
| 9 | 13383 | |
| 8 | 13270 | |
| R | 10000 | |
| T | 10000 | |
| - | 10000 | |
| N | 6653 | |
| C | 6617 | |
| E | 3383 | 3.4% |
| W | 3347 | 3.3% |
| Other values (3) | 9964 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 100000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| D | 13383 | |
| 9 | 13383 | |
| 8 | 13270 | |
| R | 10000 | |
| T | 10000 | |
| - | 10000 | |
| N | 6653 | |
| C | 6617 | |
| E | 3383 | 3.4% |
| W | 3347 | 3.3% |
| Other values (3) | 9964 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 100000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| D | 13383 | |
| 9 | 13383 | |
| 8 | 13270 | |
| R | 10000 | |
| T | 10000 | |
| - | 10000 | |
| N | 6653 | |
| C | 6617 | |
| E | 3383 | 3.4% |
| W | 3347 | 3.3% |
| Other values (3) | 9964 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 100000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| D | 13383 | |
| 9 | 13383 | |
| 8 | 13270 | |
| R | 10000 | |
| T | 10000 | |
| - | 10000 | |
| N | 6653 | |
| C | 6617 | |
| E | 3383 | 3.4% |
| W | 3347 | 3.3% |
| Other values (3) | 9964 |
policy_code
Categorical
High correlation
| Distinct | 8 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| UGP-TRCD-9834 | |
|---|---|
| JSU-TRCD-9813 | |
| LGA-TRCD-9829 | |
| STP-TRCD-9812 | |
| ICP-TRCD-9832 | |
| Other values (3) |
Length
| Max length | 13 |
|---|---|
| Median length | 13 |
| Mean length | 13 |
| Min length | 13 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | UGP-TRCD-9834 |
|---|---|
| 2nd row | UGP-TRCD-9834 |
| 3rd row | UGP-TRCD-9834 |
| 4th row | UGP-TRCD-9834 |
| 5th row | UGP-TRCD-9834 |
Common Values
| Value | Count | Frequency (%) |
| UGP-TRCD-9834 | 3205 | |
| JSU-TRCD-9813 | 2358 | |
| LGA-TRCD-9829 | 1818 | |
| STP-TRCD-9812 | 1236 | 12.4% |
| ICP-TRCD-9832 | 972 | 9.7% |
| WLS-TRCD-9814 | 329 | 3.3% |
| RSE-TRCD-9856 | 65 | 0.7% |
| GWB-TRCD-9833 | 17 | 0.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| ugp-trcd-9834 | 3205 | |
| jsu-trcd-9813 | 2358 | |
| lga-trcd-9829 | 1818 | |
| stp-trcd-9812 | 1236 | 12.4% |
| icp-trcd-9832 | 972 | 9.7% |
| wls-trcd-9814 | 329 | 3.3% |
| rse-trcd-9856 | 65 | 0.7% |
| gwb-trcd-9833 | 17 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 20000 | |
| 9 | 11818 | |
| T | 11236 | 8.6% |
| C | 10972 | 8.4% |
| R | 10065 | 7.7% |
| D | 10000 | 7.7% |
| 8 | 10000 | 7.7% |
| 3 | 6569 | 5.1% |
| U | 5563 | 4.3% |
| P | 5413 | 4.2% |
| Other values (14) | 28364 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 130000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 20000 | |
| 9 | 11818 | |
| T | 11236 | 8.6% |
| C | 10972 | 8.4% |
| R | 10065 | 7.7% |
| D | 10000 | 7.7% |
| 8 | 10000 | 7.7% |
| 3 | 6569 | 5.1% |
| U | 5563 | 4.3% |
| P | 5413 | 4.2% |
| Other values (14) | 28364 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 130000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 20000 | |
| 9 | 11818 | |
| T | 11236 | 8.6% |
| C | 10972 | 8.4% |
| R | 10065 | 7.7% |
| D | 10000 | 7.7% |
| 8 | 10000 | 7.7% |
| 3 | 6569 | 5.1% |
| U | 5563 | 4.3% |
| P | 5413 | 4.2% |
| Other values (14) | 28364 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 130000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 20000 | |
| 9 | 11818 | |
| T | 11236 | 8.6% |
| C | 10972 | 8.4% |
| R | 10065 | 7.7% |
| D | 10000 | 7.7% |
| 8 | 10000 | 7.7% |
| 3 | 6569 | 5.1% |
| U | 5563 | 4.3% |
| P | 5413 | 4.2% |
| Other values (14) | 28364 |
policy_status
Categorical
Imbalance
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| Active | |
|---|---|
| Surrendered | |
| Lapsed | 107 |
| Claimed | 37 |
Length
| Max length | 11 |
|---|---|
| Median length | 6 |
| Mean length | 7.2657 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Active |
|---|---|
| 2nd row | Active |
| 3rd row | Active |
| 4th row | Active |
| 5th row | Active |
Common Values
| Value | Count | Frequency (%) |
| Active | 7332 | |
| Surrendered | 2524 | 25.2% |
| Lapsed | 107 | 1.1% |
| Claimed | 37 | 0.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| active | 7332 | |
| surrendered | 2524 | 25.2% |
| lapsed | 107 | 1.1% |
| claimed | 37 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 15048 | |
| r | 7572 | |
| i | 7369 | |
| A | 7332 | |
| c | 7332 | |
| t | 7332 | |
| v | 7332 | |
| d | 5192 | 7.1% |
| u | 2524 | 3.5% |
| S | 2524 | 3.5% |
| Other values (8) | 3100 | 4.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 72657 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 15048 | |
| r | 7572 | |
| i | 7369 | |
| A | 7332 | |
| c | 7332 | |
| t | 7332 | |
| v | 7332 | |
| d | 5192 | 7.1% |
| u | 2524 | 3.5% |
| S | 2524 | 3.5% |
| Other values (8) | 3100 | 4.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 72657 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 15048 | |
| r | 7572 | |
| i | 7369 | |
| A | 7332 | |
| c | 7332 | |
| t | 7332 | |
| v | 7332 | |
| d | 5192 | 7.1% |
| u | 2524 | 3.5% |
| S | 2524 | 3.5% |
| Other values (8) | 3100 | 4.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 72657 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 15048 | |
| r | 7572 | |
| i | 7369 | |
| A | 7332 | |
| c | 7332 | |
| t | 7332 | |
| v | 7332 | |
| d | 5192 | 7.1% |
| u | 2524 | 3.5% |
| S | 2524 | 3.5% |
| Other values (8) | 3100 | 4.3% |
state
Categorical
High correlation
| Distinct | 22 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| Delhi | |
|---|---|
| Uttar Pradesh | |
| Sikkim | |
| Haryana | |
| Madhya Pradesh | |
| Other values (17) |
Length
| Max length | 16 |
|---|---|
| Median length | 13 |
| Mean length | 8.8023 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Delhi |
|---|---|
| 2nd row | Delhi |
| 3rd row | Delhi |
| 4th row | Delhi |
| 5th row | Delhi |
Common Values
| Value | Count | Frequency (%) |
| Delhi | 1221 | |
| Uttar Pradesh | 1120 | |
| Sikkim | 1009 | 10.1% |
| Haryana | 819 | 8.2% |
| Madhya Pradesh | 637 | 6.4% |
| Tamilnadu | 612 | 6.1% |
| Rajasthan | 550 | 5.5% |
| Bihar | 512 | 5.1% |
| Chandigarh | 463 | 4.6% |
| Uttarakhand | 458 | 4.6% |
| Other values (12) | 2599 |
Length
| Value | Count | Frequency (%) |
| pradesh | 2301 | |
| delhi | 1221 | 9.8% |
| uttar | 1120 | 9.0% |
| sikkim | 1009 | 8.1% |
| haryana | 819 | 6.6% |
| madhya | 637 | 5.1% |
| tamilnadu | 612 | 4.9% |
| rajasthan | 550 | 4.4% |
| bihar | 512 | 4.1% |
| chandigarh | 463 | 3.7% |
| Other values (14) | 3209 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 17899 | |
| h | 8562 | 9.7% |
| r | 7840 | 8.9% |
| d | 5240 | 6.0% |
| i | 5236 | 5.9% |
| e | 4402 | 5.0% |
| t | 4319 | 4.9% |
| n | 4169 | 4.7% |
| s | 3949 | 4.5% |
| k | 2992 | 3.4% |
| Other values (25) | 23415 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 88023 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 17899 | |
| h | 8562 | 9.7% |
| r | 7840 | 8.9% |
| d | 5240 | 6.0% |
| i | 5236 | 5.9% |
| e | 4402 | 5.0% |
| t | 4319 | 4.9% |
| n | 4169 | 4.7% |
| s | 3949 | 4.5% |
| k | 2992 | 3.4% |
| Other values (25) | 23415 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 88023 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 17899 | |
| h | 8562 | 9.7% |
| r | 7840 | 8.9% |
| d | 5240 | 6.0% |
| i | 5236 | 5.9% |
| e | 4402 | 5.0% |
| t | 4319 | 4.9% |
| n | 4169 | 4.7% |
| s | 3949 | 4.5% |
| k | 2992 | 3.4% |
| Other values (25) | 23415 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 88023 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 17899 | |
| h | 8562 | 9.7% |
| r | 7840 | 8.9% |
| d | 5240 | 6.0% |
| i | 5236 | 5.9% |
| e | 4402 | 5.0% |
| t | 4319 | 4.9% |
| n | 4169 | 4.7% |
| s | 3949 | 4.5% |
| k | 2992 | 3.4% |
| Other values (25) | 23415 |
rm_id
Categorical
High correlation
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| RMN7A3X1 | |
|---|---|
| RMC9F7L5 | |
| RMS4B9K2 | |
| RME2D5Q4 | |
| RMW8C6P3 |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | RMN7A3X1 |
|---|---|
| 2nd row | RMN7A3X1 |
| 3rd row | RMN7A3X1 |
| 4th row | RMN7A3X1 |
| 5th row | RMN7A3X1 |
Common Values
| Value | Count | Frequency (%) |
| RMN7A3X1 | 3799 | |
| RMC9F7L5 | 2018 | |
| RMS4B9K2 | 1661 | |
| RME2D5Q4 | 1509 | 15.1% |
| RMW8C6P3 | 1013 | 10.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| rmn7a3x1 | 3799 | |
| rmc9f7l5 | 2018 | |
| rms4b9k2 | 1661 | |
| rme2d5q4 | 1509 | 15.1% |
| rmw8c6p3 | 1013 | 10.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 10000 | 12.5% |
| M | 10000 | 12.5% |
| 7 | 5817 | 7.3% |
| 3 | 4812 | 6.0% |
| N | 3799 | 4.7% |
| A | 3799 | 4.7% |
| X | 3799 | 4.7% |
| 1 | 3799 | 4.7% |
| 9 | 3679 | 4.6% |
| 5 | 3527 | 4.4% |
| Other values (15) | 26969 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 80000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| R | 10000 | 12.5% |
| M | 10000 | 12.5% |
| 7 | 5817 | 7.3% |
| 3 | 4812 | 6.0% |
| N | 3799 | 4.7% |
| A | 3799 | 4.7% |
| X | 3799 | 4.7% |
| 1 | 3799 | 4.7% |
| 9 | 3679 | 4.6% |
| 5 | 3527 | 4.4% |
| Other values (15) | 26969 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 80000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| R | 10000 | 12.5% |
| M | 10000 | 12.5% |
| 7 | 5817 | 7.3% |
| 3 | 4812 | 6.0% |
| N | 3799 | 4.7% |
| A | 3799 | 4.7% |
| X | 3799 | 4.7% |
| 1 | 3799 | 4.7% |
| 9 | 3679 | 4.6% |
| 5 | 3527 | 4.4% |
| Other values (15) | 26969 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 80000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| R | 10000 | 12.5% |
| M | 10000 | 12.5% |
| 7 | 5817 | 7.3% |
| 3 | 4812 | 6.0% |
| N | 3799 | 4.7% |
| A | 3799 | 4.7% |
| X | 3799 | 4.7% |
| 1 | 3799 | 4.7% |
| 9 | 3679 | 4.6% |
| 5 | 3527 | 4.4% |
| Other values (15) | 26969 |
zonal_manager_id
Categorical
High correlation
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| ZMN8K2L1 | |
|---|---|
| ZMW3T7P8 | |
| ZMS5Q4R2 |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ZMN8K2L1 |
|---|---|
| 2nd row | ZMN8K2L1 |
| 3rd row | ZMN8K2L1 |
| 4th row | ZMN8K2L1 |
| 5th row | ZMN8K2L1 |
Common Values
| Value | Count | Frequency (%) |
| ZMN8K2L1 | 5817 | |
| ZMW3T7P8 | 2522 | |
| ZMS5Q4R2 | 1661 | 16.6% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| zmn8k2l1 | 5817 | |
| zmw3t7p8 | 2522 | |
| zms5q4r2 | 1661 | 16.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| Z | 10000 | |
| M | 10000 | |
| 8 | 8339 | |
| 2 | 7478 | |
| N | 5817 | 7.3% |
| K | 5817 | 7.3% |
| L | 5817 | 7.3% |
| 1 | 5817 | 7.3% |
| W | 2522 | 3.2% |
| 3 | 2522 | 3.2% |
| Other values (8) | 15871 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 80000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| Z | 10000 | |
| M | 10000 | |
| 8 | 8339 | |
| 2 | 7478 | |
| N | 5817 | 7.3% |
| K | 5817 | 7.3% |
| L | 5817 | 7.3% |
| 1 | 5817 | 7.3% |
| W | 2522 | 3.2% |
| 3 | 2522 | 3.2% |
| Other values (8) | 15871 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 80000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| Z | 10000 | |
| M | 10000 | |
| 8 | 8339 | |
| 2 | 7478 | |
| N | 5817 | 7.3% |
| K | 5817 | 7.3% |
| L | 5817 | 7.3% |
| 1 | 5817 | 7.3% |
| W | 2522 | 3.2% |
| 3 | 2522 | 3.2% |
| Other values (8) | 15871 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 80000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| Z | 10000 | |
| M | 10000 | |
| 8 | 8339 | |
| 2 | 7478 | |
| N | 5817 | 7.3% |
| K | 5817 | 7.3% |
| L | 5817 | 7.3% |
| 1 | 5817 | 7.3% |
| W | 2522 | 3.2% |
| 3 | 2522 | 3.2% |
| Other values (8) | 15871 |
payment_frequency_days
Categorical
High correlation
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| 90 | |
|---|---|
| 30 | |
| 365 |
Length
| Max length | 3 |
|---|---|
| Median length | 2 |
| Mean length | 2.3244 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 30 |
|---|---|
| 2nd row | 365 |
| 3rd row | 90 |
| 4th row | 365 |
| 5th row | 30 |
Common Values
| Value | Count | Frequency (%) |
| 90 | 3432 | |
| 30 | 3324 | |
| 365 | 3244 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 90 | 3432 | |
| 30 | 3324 | |
| 365 | 3244 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 6756 | |
| 3 | 6568 | |
| 9 | 3432 | |
| 6 | 3244 | |
| 5 | 3244 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 23244 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 6756 | |
| 3 | 6568 | |
| 9 | 3432 | |
| 6 | 3244 | |
| 5 | 3244 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 23244 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 6756 | |
| 3 | 6568 | |
| 9 | 3432 | |
| 6 | 3244 | |
| 5 | 3244 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 23244 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 6756 | |
| 3 | 6568 | |
| 9 | 3432 | |
| 6 | 3244 | |
| 5 | 3244 |
Interactions
Correlations
| loan_amount_allowed | loan_eligible | payment_frequency | payment_frequency_days | policy_code | policy_status | policy_type_code | premium_amount | purchase_month | purchase_quarter | purchase_year | rm_id | sales_agent_code | state | sum_assured_inr/coverage_amount | tenure_(years) | underwriting_expenses | zonal_manager_id | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| loan_amount_allowed | 1.000 | 0.000 | 0.022 | 0.022 | 0.006 | 0.008 | 0.013 | -0.006 | 0.010 | 0.011 | 0.002 | 0.000 | 0.000 | 0.000 | 0.937 | -0.007 | -0.010 | 0.000 |
| loan_eligible | 0.000 | 1.000 | 0.000 | 0.000 | 0.021 | 0.029 | 0.000 | 0.000 | 0.000 | 0.005 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.008 | 0.000 |
| payment_frequency | 0.022 | 0.000 | 1.000 | 1.000 | 0.013 | 0.007 | 0.010 | 0.000 | 0.022 | 0.020 | 0.000 | 0.009 | 0.026 | 0.026 | 0.019 | 0.000 | 0.000 | 0.004 |
| payment_frequency_days | 0.022 | 0.000 | 1.000 | 1.000 | 0.013 | 0.007 | 0.010 | 0.000 | 0.022 | 0.020 | 0.000 | 0.009 | 0.026 | 0.026 | 0.019 | 0.000 | 0.000 | 0.004 |
| policy_code | 0.006 | 0.021 | 0.013 | 0.013 | 1.000 | 0.123 | 1.000 | 0.010 | 0.000 | 0.005 | 0.000 | 0.163 | 0.232 | 0.232 | 0.000 | 1.000 | 0.024 | 0.217 |
| policy_status | 0.008 | 0.029 | 0.007 | 0.007 | 0.123 | 1.000 | 0.000 | 0.005 | 0.000 | 0.000 | 0.000 | 0.138 | 0.298 | 0.298 | 0.010 | 0.086 | 0.007 | 0.072 |
| policy_type_code | 0.013 | 0.000 | 0.010 | 0.010 | 1.000 | 0.000 | 1.000 | 0.007 | 0.000 | 0.011 | 0.005 | 0.004 | 0.036 | 0.036 | 0.000 | 0.871 | 0.000 | 0.004 |
| premium_amount | -0.006 | 0.000 | 0.000 | 0.000 | 0.010 | 0.005 | 0.007 | 1.000 | 0.009 | 0.003 | -0.015 | 0.015 | 0.006 | 0.006 | -0.007 | -0.009 | 0.008 | 0.023 |
| purchase_month | 0.010 | 0.000 | 0.022 | 0.022 | 0.000 | 0.000 | 0.000 | 0.009 | 1.000 | 1.000 | 0.082 | 0.009 | 0.000 | 0.000 | 0.017 | 0.006 | 0.015 | 0.013 |
| purchase_quarter | 0.011 | 0.005 | 0.020 | 0.020 | 0.005 | 0.000 | 0.011 | 0.003 | 1.000 | 1.000 | 0.133 | 0.012 | 0.000 | 0.000 | 0.022 | 0.007 | 0.008 | 0.006 |
| purchase_year | 0.002 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.005 | -0.015 | 0.082 | 0.133 | 1.000 | 0.009 | 0.005 | 0.005 | 0.010 | -0.009 | -0.016 | 0.000 |
| rm_id | 0.000 | 0.000 | 0.009 | 0.009 | 0.163 | 0.138 | 0.004 | 0.015 | 0.009 | 0.012 | 0.009 | 1.000 | 0.999 | 0.999 | 0.000 | 0.108 | 0.000 | 1.000 |
| sales_agent_code | 0.000 | 0.000 | 0.026 | 0.026 | 0.232 | 0.298 | 0.036 | 0.006 | 0.000 | 0.000 | 0.005 | 0.999 | 1.000 | 1.000 | 0.000 | 0.183 | 0.005 | 0.999 |
| state | 0.000 | 0.000 | 0.026 | 0.026 | 0.232 | 0.298 | 0.036 | 0.006 | 0.000 | 0.000 | 0.005 | 0.999 | 1.000 | 1.000 | 0.000 | 0.183 | 0.005 | 0.999 |
| sum_assured_inr/coverage_amount | 0.937 | 0.000 | 0.019 | 0.019 | 0.000 | 0.010 | 0.000 | -0.007 | 0.017 | 0.022 | 0.010 | 0.000 | 0.000 | 0.000 | 1.000 | -0.007 | -0.009 | 0.000 |
| tenure_(years) | -0.007 | 0.000 | 0.000 | 0.000 | 1.000 | 0.086 | 0.871 | -0.009 | 0.006 | 0.007 | -0.009 | 0.108 | 0.183 | 0.183 | -0.007 | 1.000 | 0.009 | 0.145 |
| underwriting_expenses | -0.010 | 0.008 | 0.000 | 0.000 | 0.024 | 0.007 | 0.000 | 0.008 | 0.015 | 0.008 | -0.016 | 0.000 | 0.005 | 0.005 | -0.009 | 0.009 | 1.000 | 0.005 |
| zonal_manager_id | 0.000 | 0.000 | 0.004 | 0.004 | 0.217 | 0.072 | 0.004 | 0.023 | 0.013 | 0.006 | 0.000 | 1.000 | 0.999 | 0.999 | 0.000 | 0.145 | 0.005 | 1.000 |
Missing values
Sample
| policy_number | start_date | last_paid_date | tenure_(years) | date_of_purchase | customer_id | sum_assured_inr/coverage_amount | premium_amount | payment_frequency | loan_eligible | loan_amount_allowed | underwriting_expenses | sales_agent_code | purchase_month | purchase_quarter | purchase_year | policy_anniversary_date | claim_id | policy_type_code | policy_code | policy_status | state | rm_id | zonal_manager_id | payment_frequency_days | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | TRS-POL-287638 | 28-01-2017 | 28-Jan-25 | 20 | 28-Jan-17 | CUST-912138 | 1837929.13 | 18946.30 | Monthly | No | 709501.06 | 9003.34 | AGT-6578 | January | Q1 | 2017 | 28-Jan-18 | CLM-163983 | TR-UNCD988 | UGP-TRCD-9834 | Active | Delhi | RMN7A3X1 | ZMN8K2L1 | 30 |
| 1 | TRS-POL-983850 | 27-10-2017 | 27-Oct-25 | 20 | 27-Oct-17 | CUST-676760 | 143416.16 | 64648.36 | Annually | Yes | 73432.27 | 2808.23 | AGT-6578 | October | Q4 | 2017 | 27-Oct-18 | CLM-729665 | TR-UNCD988 | UGP-TRCD-9834 | Active | Delhi | RMN7A3X1 | ZMN8K2L1 | 365 |
| 2 | TRS-POL-892387 | 18-04-2022 | 18-Apr-25 | 20 | 18-Apr-22 | CUST-189349 | 619301.17 | 42085.47 | Quarterly | Yes | 361902.11 | 3335.88 | AGT-6578 | April | Q2 | 2022 | 18-Apr-23 | CLM-655001 | TR-UNCD988 | UGP-TRCD-9834 | Active | Delhi | RMN7A3X1 | ZMN8K2L1 | 90 |
| 3 | TRS-POL-204292 | 20-11-2019 | 20-Nov-25 | 20 | 20-Nov-19 | CUST-567423 | 1852545.62 | 97105.30 | Annually | Yes | 732352.54 | 4715.71 | AGT-6578 | November | Q4 | 2019 | 20-Nov-20 | CLM-101156 | TR-UNCD988 | UGP-TRCD-9834 | Active | Delhi | RMN7A3X1 | ZMN8K2L1 | 365 |
| 4 | TRS-POL-621019 | 13-02-2023 | 13-Feb-25 | 20 | 13-Feb-23 | CUST-292627 | 1882565.42 | 89233.91 | Monthly | No | 864927.02 | 5166.29 | AGT-6578 | February | Q1 | 2023 | 13-Feb-24 | CLM-762598 | TR-UNCD988 | UGP-TRCD-9834 | Active | Delhi | RMN7A3X1 | ZMN8K2L1 | 30 |
| 5 | TRS-POL-603900 | 19-04-2019 | 19-Apr-25 | 20 | 19-Apr-19 | CUST-802812 | 1330929.44 | 24594.09 | Quarterly | Yes | 503997.37 | 7587.61 | AGT-6578 | April | Q2 | 2019 | 19-Apr-20 | CLM-739868 | TR-UNCD988 | UGP-TRCD-9834 | Active | Delhi | RMN7A3X1 | ZMN8K2L1 | 90 |
| 6 | TRS-POL-371850 | 26-08-2016 | 26-Aug-25 | 20 | 26-Aug-16 | CUST-285115 | 1852113.26 | 33450.86 | Annually | No | 824389.81 | 7388.20 | AGT-6578 | August | Q3 | 2016 | 26-Aug-17 | CLM-590747 | TR-UNCD988 | UGP-TRCD-9834 | Active | Delhi | RMN7A3X1 | ZMN8K2L1 | 365 |
| 7 | TRS-POL-336174 | 12-08-2019 | 12-Aug-25 | 20 | 12-Aug-19 | CUST-541584 | 714993.62 | 76687.52 | Quarterly | Yes | 261604.73 | 4288.23 | AGT-6578 | August | Q3 | 2019 | 12-Aug-20 | CLM-597333 | TR-UNCD988 | UGP-TRCD-9834 | Active | Delhi | RMN7A3X1 | ZMN8K2L1 | 90 |
| 8 | TRS-POL-745853 | 14-11-2016 | 14-Nov-25 | 20 | 14-Nov-16 | CUST-192788 | 270848.26 | 18826.75 | Quarterly | Yes | 141297.41 | 6725.00 | AGT-6578 | November | Q4 | 2016 | 14-Nov-17 | CLM-765047 | TR-UNCD988 | UGP-TRCD-9834 | Active | Delhi | RMN7A3X1 | ZMN8K2L1 | 90 |
| 9 | TRS-POL-192191 | 06-01-2023 | 06-Jan-25 | 20 | 06-Jan-23 | CUST-226778 | 1500910.12 | 71206.95 | Annually | Yes | 886258.09 | 1346.17 | AGT-6578 | January | Q1 | 2023 | 06-Jan-24 | CLM-790890 | TR-UNCD988 | UGP-TRCD-9834 | Active | Delhi | RMN7A3X1 | ZMN8K2L1 | 365 |
| policy_number | start_date | last_paid_date | tenure_(years) | date_of_purchase | customer_id | sum_assured_inr/coverage_amount | premium_amount | payment_frequency | loan_eligible | loan_amount_allowed | underwriting_expenses | sales_agent_code | purchase_month | purchase_quarter | purchase_year | policy_anniversary_date | claim_id | policy_type_code | policy_code | policy_status | state | rm_id | zonal_manager_id | payment_frequency_days | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9990 | TRS-POL-820102 | 12-09-2023 | 12-Sep-24 | 20 | 12-Sep-23 | CUST-541253 | 1967825.03 | 87386.80 | Annually | Yes | 1118956.65 | 3921.03 | AGT-7898 | September | Q3 | 2023 | 12-Sep-24 | CLM-912030 | TR-UNCD988 | UGP-TRCD-9834 | Surrendered | Uttarakhand | RMN7A3X1 | ZMN8K2L1 | 365 |
| 9991 | TRS-POL-525507 | 19-08-2017 | 19-Aug-20 | 20 | 19-Aug-17 | CUST-988183 | 1446839.21 | 60380.44 | Monthly | Yes | 456004.58 | 7381.60 | AGT-7898 | August | Q3 | 2017 | 19-Aug-18 | CLM-591517 | TR-UNCD988 | UGP-TRCD-9834 | Surrendered | Uttarakhand | RMN7A3X1 | ZMN8K2L1 | 30 |
| 9992 | TRS-POL-329212 | 20-11-2021 | 20-Nov-23 | 20 | 20-Nov-21 | CUST-461264 | 859050.29 | 46748.59 | Monthly | Yes | 319082.84 | 3629.81 | AGT-7898 | November | Q4 | 2021 | 20-Nov-22 | CLM-862321 | TR-UNCD988 | UGP-TRCD-9834 | Surrendered | Uttarakhand | RMN7A3X1 | ZMN8K2L1 | 30 |
| 9993 | TRS-POL-146807 | 01-05-2018 | 01-May-21 | 20 | 01-May-18 | CUST-970886 | 673382.05 | 11430.65 | Quarterly | Yes | 233625.16 | 9297.07 | AGT-7898 | May | Q2 | 2018 | 01-May-19 | CLM-695622 | TR-UNCD988 | UGP-TRCD-9834 | Surrendered | Uttarakhand | RMN7A3X1 | ZMN8K2L1 | 90 |
| 9994 | TRS-POL-432041 | 25-08-2023 | 25-Aug-24 | 20 | 25-Aug-23 | CUST-563060 | 387560.56 | 42480.40 | Annually | Yes | 223900.87 | 5700.98 | AGT-7898 | August | Q3 | 2023 | 25-Aug-24 | CLM-290388 | TR-UNCD988 | UGP-TRCD-9834 | Surrendered | Uttarakhand | RMN7A3X1 | ZMN8K2L1 | 365 |
| 9995 | TRS-POL-465487 | 07-12-2017 | 07-Dec-20 | 20 | 07-Dec-17 | CUST-439248 | 302465.10 | 21576.84 | Monthly | Yes | 154790.07 | 6890.88 | AGT-7898 | December | Q4 | 2017 | 07-Dec-18 | CLM-934830 | TR-UNCD988 | UGP-TRCD-9834 | Surrendered | Uttarakhand | RMN7A3X1 | ZMN8K2L1 | 30 |
| 9996 | TRS-POL-956994 | 19-04-2020 | 19-Apr-22 | 20 | 19-Apr-20 | CUST-239999 | 204448.30 | 59548.60 | Monthly | No | 112221.94 | 8675.45 | AGT-7898 | April | Q2 | 2020 | 19-Apr-21 | CLM-507329 | TR-UNCD988 | UGP-TRCD-9834 | Surrendered | Uttarakhand | RMN7A3X1 | ZMN8K2L1 | 30 |
| 9997 | TRS-POL-461662 | 15-07-2019 | 15-Jul-21 | 20 | 15-Jul-19 | CUST-400763 | 658445.39 | 67869.60 | Annually | Yes | 322829.68 | 8633.53 | AGT-7898 | July | Q3 | 2019 | 15-Jul-20 | CLM-465856 | TR-UNCD988 | UGP-TRCD-9834 | Surrendered | Uttarakhand | RMN7A3X1 | ZMN8K2L1 | 365 |
| 9998 | TRS-POL-401998 | 09-03-2017 | 09-Mar-20 | 20 | 09-Mar-17 | CUST-684678 | 1748404.03 | 62139.29 | Quarterly | Yes | 826357.54 | 7101.07 | AGT-7898 | March | Q1 | 2017 | 09-Mar-18 | CLM-533930 | TR-UNCD988 | UGP-TRCD-9834 | Surrendered | Uttarakhand | RMN7A3X1 | ZMN8K2L1 | 90 |
| 9999 | TRS-POL-894552 | 26-01-2020 | 26-Jan-22 | 20 | 26-Jan-20 | CUST-510641 | 472185.45 | 96062.59 | Monthly | No | 199802.21 | 3369.91 | AGT-7898 | January | Q1 | 2020 | 26-Jan-21 | CLM-113772 | TR-UNCD988 | UGP-TRCD-9834 | Surrendered | Uttarakhand | RMN7A3X1 | ZMN8K2L1 | 30 |